TrimEnters

SQL Function to remove repeated Enters from a string in SQL Chr(13) + Chr(10)

DB_Connect_Install

Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...

DB_Connect_Install.zip

DB_Connect

VBA-Excel function to connect to SQL Database server, in addition to ...

Remove_Between2Quotes

Remove any char (or string) found between two quotes in a string This is an ...

all_tab_columns

List all columns in all tables for all schemas in oracle db workbench

Random GUID

Generate a random GUID using oracle db workbench Also add timestamp to ensure ...

GeneratePostID

Two functions to generate ID that is unique (not found in database) ...

AN_SafeFileName

Clean filename from special characters to make it safe for server upload Then ...

List of Databases

Script to list databases available in a server using ADODB connection From

Char(39) in SQL table

One of many ways to go around the issue of char 39 in SQL database

DB_ExtendedProperties

Returns extended properties of a database, knowing the ADODB connection

HeadingZeros Remove and Add

Adds or remove zeros at start of string Used to clear heading zeros from ...